package com.ncpowernode.mapper;

import com.ncpowernode.pojo.Item;
import org.apache.ibatis.annotations.Insert;
import org.apache.ibatis.annotations.Select;

import java.util.List;

public interface ItemMapper {

    @Insert("insert into jd_item values(null,#{spu},#{sku},#{title},#{price},#{pic},#{url},#{created},#{updated})")
    int save(Item item);

    @Select("select * from jd_item where sku=#{sku}")
    List<Item> selectAll(Item item);

}
